CREATE TABLE [dbo].[Receipt]
(
[ID] [int] NOT NULL CONSTRAINT [DF_Receipt_ID] DEFAULT ((0)),
[Auto_Receipt_Num] [int] NOT NULL CONSTRAINT [DF_Receipt_Auto_Receipt_Num] DEFAULT ((0)),
[Name_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Receipt_Name_ID] DEFAULT (''),
[Batch_Num] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Receipt_Batch_Num] DEFAULT (''),
[Canceled_Receipt_ID] [int] NOT NULL CONSTRAINT [DF_Receipt_Canceled_Receipt_ID] DEFAULT ((0)),
[Canceled] [tinyint] NOT NULL CONSTRAINT [DF_Receipt_Canceled] DEFAULT ((0)),
[Date_Issued] [datetime] NULL,
[Note] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Receipt_Note] DEFAULT (''),
[Manual_Receipt_Num] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Receipt_Manual_Receipt_Num] DEFAULT (''),
[Aggregate_Indicator] [tinyint] NOT NULL CONSTRAINT [DF_Receipt_Aggregate_Indicator] DEFAULT ((0)),
[Amount] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Receipt_Amount] DEFAULT ((0)),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX [iReceiptAggregate_Payment] ON [dbo].[Receipt] ([Aggregate_Indicator]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iReceiptAmount] ON [dbo].[Receipt] ([Amount]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iReceiptAuto_Receipt_Num] ON [dbo].[Receipt] ([Auto_Receipt_Num]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iReceiptBatch_Num] ON [dbo].[Receipt] ([Batch_Num]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iReceiptCanceled] ON [dbo].[Receipt] ([Canceled]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iReceiptCanceled_Receipt_ID] ON [dbo].[Receipt] ([Canceled_Receipt_ID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iReceiptDate_Issued] ON [dbo].[Receipt] ([Date_Issued]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iReceiptID] ON [dbo].[Receipt] ([ID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iReceiptManual_Receipt_Num] ON [dbo].[Receipt] ([Manual_Receipt_Num]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iReceiptName_ID] ON [dbo].[Receipt] ([Name_ID]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Receipt] TO [IMIS]
GRANT SELECT ON  [dbo].[Receipt] TO [IMIS]
GRANT INSERT ON  [dbo].[Receipt] TO [IMIS]
GRANT DELETE ON  [dbo].[Receipt] TO [IMIS]
GRANT UPDATE ON  [dbo].[Receipt] TO [IMIS]
GO